Spreadsheet vs. multiagent-based simulations in the study of decision making in supply chains

A game called the Quebec Wood Supply Game (QWSG) is a role-playing simulation based on the Beer Game for teaching supply chain dynamics, and, in particular, the bullwhip effect. In this context, this paper describes and compares two simulators based on the QWSG which may be used to study decision making and its impact on supply chain dynamics. We first focus on the direct implementation of the QWSG in a spreadsheet program. This spreadsheet model is the base on which we next build a more complex MultiAgent Based Simulation (MABS) in which JACK agents represent companies. Finally, we compare the respective advantages of each simulator. We identify the features of a supply chain model making a spreadsheet simulation impossible, and those for which a spreadsheet simulation is better, as good as, or worse than MABS.